﻿using System;

namespace ZealousTTS.Domain
{
    public static class DbObject
    {
        /// <summary>
        /// Contains the Names of the Stored Procedures
        /// </summary>
        public static class SP
        {
            public const String GET_PAGED_PRODUCTS_BY_COMPANY = "dbo.GetPagedProductsByCompany";
            public const String GET_PAGED_PRODUCTS_BY_CATEGORY = "dbo.GetPagedProductsByCategory";
            public const String GET_CONTACTS_BY_COMPANY = "dbo.GetContactsByCompany";
            public const String GET_USERS_BY_COMPANY = "dbo.GetUsersByCompany";
            public const String GET_PRODUCT_RANDOMLY = "dbo.GetPagedRandomProduct";
            public const String GET_PRODUCT_BY_SEARCH = "dbo.GetPagedProductBySearch";
            public const String GET_PRODUCT_POPULAR_SEARCH = "dbo.GetPagedProductByPopularSearch";
            //public const String GET_PRODUCT_BY_LATEST_ADDED = "dbo.GetProductByLatestAdded";

            public const string GET_PROJECT_STATUS = "dbo.Pro_project";

            //public const String GET_PRODUCT_BY_LATEST_UPDATED = "dbo.GetProductByLatestUpdated";
            public const String GET_PRODUCT_BY_DISCOUNT_PRODUCTS = "dbo.GetPagedProductByDiscount";
            public const String GET_PRODUCT_BY_SPECIAL_OFFERS = "dbo.GetPagedProductBySpecialOffers";

            public const String GET_CONTENT = "dbo.GetContentList";
        }

        /// <summary>
        /// Contains the Names of the Database Functions
        /// </summary>
        public static class Function
        {
            
        }
        
        /// <summary>
        /// Conntains the Names of the Database Views
        /// </summary>
        public static class View
        {

        }
    }
}
